using System;
using System.Data;
using System.Configuration;
using System.IO;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// 
/// </summary>
public class GridViewExportUtil
{
    /// <summary>
    /// 
    /// </summary>
    /// <param name="fileName"></param>
    /// <param name="gv"></param>
    public static void Export(string fileName, GridView gv, string DealTitle, string VName, string DealTo, string DealFrom)
    {
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.AddHeader(
            "content-disposition", string.Format("attachment; filename={0}", fileName));
        HttpContext.Current.Response.ContentType = "application/ms-excel";

        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter htw = new HtmlTextWriter(sw))
            {
                //  Create a form to contain the grid
                Table table = new Table();
              //----------------------------------------
                Label Vendor = new Label();
                Label VendorName = new Label();

                TableRow row1 = new TableRow();
                TableCell cell1 = new TableCell();
                TableCell cell2 = new TableCell();

                cell1.Controls.Add(Vendor);
                Vendor.ID = "lblVendor";
                Vendor.Text = "<b>Vendor Name</b>";

                cell2.Controls.Add(VendorName);
                VendorName.ID = "lblVendorName";
                VendorName.Text = VName;

                row1.Cells.Add(cell1);
                row1.Cells.Add(cell2);
                table.Rows.Add(row1);

                //----------------------------------------
           
                Label Deal = new Label();
                Label DealName = new Label();

                TableRow row2 = new TableRow();
                TableCell cell3= new TableCell();
                TableCell cell4 = new TableCell();

                cell3.Controls.Add(Deal);
                
                Deal.ID = "lblDeal";
                Deal.Text = "<b>Deal Title</b>";

                cell4.Controls.Add(DealName);
                cell4.ColumnSpan = 6; 
                DealName.ID = "lblDealTitle";
                DealName.Text = DealTitle;
               
                row2.Cells.Add(cell3);
                row2.Cells.Add(cell4);
                table.Rows.Add(row2);
                //----------------------------------------
                Label DealStartTo = new Label();
                Label DealStartDateTo = new Label();
                TableRow row3 = new TableRow();
                TableCell cell5 = new TableCell();
                TableCell cell6 = new TableCell();

                cell5.Controls.Add(DealStartTo);
                DealStartTo.ID = "lblDealStartTo";
                DealStartTo.Text = "<b>Deal From</b>";

                cell6.Controls.Add(DealStartDateTo);
                DealStartDateTo.ID = "lblDealStartDateTo";
                DealStartDateTo.Text = DealTo;
              

                row3.Cells.Add(cell5);
                row3.Cells.Add(cell6);
                table.Rows.Add(row3);
                //----------------------------------------
                Label DealEndFrom = new Label();
                Label DealEndDateFrom = new Label();
                TableRow row4 = new TableRow();
                TableCell cell7 = new TableCell();
                TableCell cell8 = new TableCell();

                cell7.Controls.Add(DealEndFrom);
                DealEndFrom.ID = "lblDealStartTo";
                DealEndFrom.Text = "<b>Deal To</b>";

                cell8.Controls.Add(DealEndDateFrom);
                DealEndDateFrom.ID = "lblDealStartDateTo";
                DealEndDateFrom.Text = DealFrom;


                row4.Cells.Add(cell7);
                row4.Cells.Add(cell8);
                table.Rows.Add(row4);
                //----------------------------------------
                Label lbl = new Label();
               
                TableRow row5 = new TableRow();
                TableCell cell9 = new TableCell();


                cell9.Controls.Add(lbl);
                lbl.ID = "lbl1";
                lbl.Text = "&nbsp;";              


                row5.Cells.Add(cell9);
             
                table.Rows.Add(row5);
                //  add the header row to the table
                if (gv.HeaderRow != null)
                {
                    GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);
                    table.Rows.Add(gv.HeaderRow);
                }

                //  add each of the data rows to the table
                foreach (GridViewRow row in gv.Rows)
                {
                    GridViewExportUtil.PrepareControlForExport(row);
                    table.Rows.Add(row);
                }

                //  add the footer row to the table
                if (gv.FooterRow != null)
                {
                    GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
                    table.Rows.Add(gv.FooterRow);
                }

                //  render the table into the htmlwriter
                table.RenderControl(htw);

                //  render the htmlwriter into the response
                HttpContext.Current.Response.Write(sw.ToString());
                HttpContext.Current.Response.End();
            }
        }
    }

    /// <summary>
    /// Replace any of the contained controls with literals
    /// </summary>
    /// <param name="control"></param>
    private static void PrepareControlForExport(Control control)
    {
        for (int i = 0; i < control.Controls.Count; i++)
        {
            Control current = control.Controls[i];
            if (current is LinkButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
            }
            else if (current is ImageButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
            }
            else if (current is HyperLink)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
            }
            else if (current is DropDownList)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
            }
            else if (current is CheckBox)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
            }

            if (current.HasControls())
            {
                GridViewExportUtil.PrepareControlForExport(current);
            }
        }
    }
}
